|
Function / Event |
Return Value |
Description |
Syntax |
|
Text |
|||
|
Compare two Strings Ignoring Case |
Boolean |
Compares two given text values. While comparing, this operation ignores the case of the text. |
Compare <string1> with <string2> case independently |
|
Concatenate |
Text |
Concatenates the specified texts. |
Concatenate <List Of Text > |
|
Convert To Lower Case |
Text |
Converts all uppercase letters in a specified text to lower case. |
Convert <Text> To Lower Case |
|
Convert To Upper Case |
Text |
Converts all lowercase letters in a specified text to upper case. |
Convert <Text> To Upper Case |
|
Extract Prefix Subtext Which Excludes Character Set |
Text |
Extracts the left-most sequence of the text that does not contain characters from a given set; extraction ceases when a character that is included in the set is found. |
Extract Prefix Subtext Of <Text> Which Excludes <Character Set> |
|
Extract Prefix Subtext Which Includes Character Set |
Text |
Extracts the left-most sequence of the text that contains characters from a given set; extraction ceases when a character that is not included in the set is found. |
Extract Prefix Subtext Of <Text> Which Includes <Character Set> |
|
Extract Subtext |
Text |
Extracts a subtext of a specified length from the source text, starting at the specified position (1-based). |
Extract Subtext Of <Length In Characters> From <Source Text> Starting At <Start Position> |
|
Find Char Position |
Number |
Finds the first position (1-based) of any of the characters in a set in a specified text. |
Find Any Character From <Character Set> in <Text> |
|
Find Subtext Position |
Number |
Finds the start index (1-based) of a subtext in a text. |
Find <Subtext> Position In <Text> Starting At <Start Position> |
|
Find Subtext Using Wildcard |
Number |
Finds the position of a subtext in a text. Wildcard characters (any number of ? or a single *) can be used in the same manner of the LIKE operator of SQL. |
Find <Subtext> In <Text> Using Wildcard Characters |
|
Insert Subtext |
Text |
Inserts a subtext into a text, according to a specified subtext and location. |
Insert Subtext <Text To Insert> Into <Target Text> At <Insert Position> |
|
Is Empty Or Has Spaces |
Boolean |
Checks whether the given text is empty or contains only spaces. |
Check if <inputString> is empty or contains only spaces |
|
Length Of Text |
Number |
Counts the characters in a text. |
Length Of <Text> |
|
Logical to Visual |
Text |
Converts a string from logical to visual. This is used for international text such as Hebrew. For more information, see Visual vs. logical ordering of text. (This link was active at the time of this publication. It is not maintained by NICE.) |
<Text> |
|
Pad Text |
Text |
Concatenates a text with another text according to a specified number of repetitions and a specified length. |
Pad <Text> From <Left To Right> Up To <Length> With <Text To Repeat> |
|
Remove Spaces From String |
Text |
Removes all occurrences of white spaces from the specified text. |
Remove all occurrences of white space characters from <inputString> |
|
Repeat Text |
Text |
Concatenates a given number of text repetitions. |
Repeat <Text> <Number Of Repetitions> Times |
|
Replace Subtext |
Text |
Replaces a character or subtext with another in the specified text. |
Replace <Subtext> In <Text> By <Alternative Text> <Number Of Replacements> |
|
Reverse Extract Subtext |
Text |
Extracts a subtext of a specified length from the source text, starting at the end of the source text. |
Reverse Extract Subtext of <Length In Characters> From <Source Text> |
|
Reverse Find Subtext |
Number |
Finds the start index (1-based) of a subtext in a text starting at the end of the text. |
Reverse Find <Subtext> Position In <Text> |
|
Reverse The Order Of Characters |
Text |
Reverses the order of the characters in the text. |
Reverse The Order Of Characters In <Text> |
|
Split |
List of text |
Splits the text by a delimiter and outputs the result as a text list. |
Split <Text> By <Delimiter> Into A Text List |
|
Split by delimiters |
List of text |
Splits the text by one or more delimiters and outputs the result as a text list. |
Split <text> by one or more delimiters <Add delimiter> into a list of text |
|
Substring from Left of the String |
Text |
Extracts a substring with the specified length from the left of the source text. Returns the extracted text. For example, you specify the length as 5, and the source text as Hello World. The function will return Hello as the extracted text. |
Extract subtext from left of <inputString> of length <number> |
|
Substring from Right of the String |
Text |
Extracts a substring with the specified length from the left of the source text. Returns the extracted text. For example, you specify the length as 5, and the source text as Hello World. The function will return World as the extracted text. |
Extract subtext from right of <inputString> of length <number> |
|
Trim |
Text |
Removes all occurrences of white space characters from the beginning and end of the specified text. |
Trim <Text> |
|
Trim End |
Text |
Removes all occurrences of white space characters from the end of the specified text. |
Trim End <Text> |
|
Trim Start |
Text |
Removes all occurrences of white space characters from the beginning of the specified text. |
Trim Start <Text> |
|
Wild Compare |
Boolean |
Compares the specified text to the specified pattern using case-sensitive criteria according to specification (wild cards are * and ?). |
Wild Compare <Text> To <Pattern> Using <Case Sensitive> |